Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$MVREFRESH

`V$MVREFRESH` displays information about the materialized views currently being refreshed.

Column | Datatype | Description
--- | --- | ---
`SID` | `NUMBER` | Session identifier
`SERIAL#` | `NUMBER` | Session serial number, which is used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends with, and another session begins with, the same session ID.
`CURRMVOWNER` | `VARCHAR2(31)` | Owner of the materialized view currently being refreshed. The materialized view resides in this user's schema.
`CURRMVNAME` | `VARCHAR2(31)` | Name of the materialized view currently being refreshed